Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 10194 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 8.9 MiB |
| Average record size in memory | 913.4 B |
Variable types
| Numeric | 5 |
|---|---|
| Text | 8 |
| DateTime | 2 |
| Categorical | 6 |
Category is highly overall correlated with Sub-Category | High correlation |
Discount is highly overall correlated with Profit | High correlation |
Profit is highly overall correlated with Discount and 1 other fields | High correlation |
Sales is highly overall correlated with Profit | High correlation |
Sub-Category is highly overall correlated with Category | High correlation |
Country/Region is highly imbalanced (86.1%) | Imbalance |
Row ID is uniformly distributed | Uniform |
Row ID has unique values | Unique |
Discount has 4925 (48.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-05-18 11:11:27.754929 |
|---|---|
| Analysis finished | 2025-05-18 11:11:32.908748 |
| Duration | 5.15 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Row ID
Real number (ℝ)
Uniform Unique
| Distinct | 10194 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5097.5 |
| Minimum | 1 |
|---|---|
| Maximum | 10194 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 510.65 |
| Q1 | 2549.25 |
| median | 5097.5 |
| Q3 | 7645.75 |
| 95-th percentile | 9684.35 |
| Maximum | 10194 |
| Range | 10193 |
| Interquartile range (IQR) | 5096.5 |
Descriptive statistics
| Standard deviation | 2942.8987 |
|---|---|
| Coefficient of variation (CV) | 0.57732195 |
| Kurtosis | -1.2 |
| Mean | 5097.5 |
| Median Absolute Deviation (MAD) | 2548.5 |
| Skewness | 0 |
| Sum | 51963915 |
| Variance | 8660652.5 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 6800 | 1 | < 0.1% |
| 6793 | 1 | < 0.1% |
| 6794 | 1 | < 0.1% |
| 6795 | 1 | < 0.1% |
| 6796 | 1 | < 0.1% |
| 6797 | 1 | < 0.1% |
| 6798 | 1 | < 0.1% |
| 6799 | 1 | < 0.1% |
| 6801 | 1 | < 0.1% |
| Other values (10184) | 10184 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 10194 | 1 | |
| 10193 | 1 | |
| 10192 | 1 | |
| 10191 | 1 | |
| 10190 | 1 | |
| 10189 | 1 | |
| 10188 | 1 | |
| 10187 | 1 | |
| 10186 | 1 | |
| 10185 | 1 |
Order ID
Text
| Distinct | 5111 |
|---|---|
| Distinct (%) | 50.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 627.3 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 2593 ? |
|---|---|
| Unique (%) | 25.4% |
Sample
| 1st row | US-2021-103800 |
|---|---|
| 2nd row | US-2021-112326 |
| 3rd row | US-2021-112326 |
| 4th row | US-2021-112326 |
| 5th row | US-2021-141817 |
| Value | Count | Frequency (%) |
| us-2024-100111 | 14 | 0.1% |
| us-2024-157987 | 12 | 0.1% |
| us-2023-108504 | 11 | 0.1% |
| us-2023-165330 | 11 | 0.1% |
| us-2022-131338 | 10 | 0.1% |
| us-2023-105732 | 10 | 0.1% |
| us-2022-126977 | 10 | 0.1% |
| us-2022-164882 | 9 | 0.1% |
| us-2023-114013 | 9 | 0.1% |
| us-2022-163433 | 9 | 0.1% |
| Other values (5101) | 10089 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 28046 | |
| - | 20388 | |
| 1 | 17879 | |
| 0 | 15757 | |
| U | 9994 | 7.0% |
| S | 9994 | 7.0% |
| 4 | 8865 | 6.2% |
| 3 | 8205 | 5.7% |
| 6 | 5429 | 3.8% |
| 5 | 5376 | 3.8% |
| Other values (5) | 12783 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 142716 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 28046 | |
| - | 20388 | |
| 1 | 17879 | |
| 0 | 15757 | |
| U | 9994 | 7.0% |
| S | 9994 | 7.0% |
| 4 | 8865 | 6.2% |
| 3 | 8205 | 5.7% |
| 6 | 5429 | 3.8% |
| 5 | 5376 | 3.8% |
| Other values (5) | 12783 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 142716 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 28046 | |
| - | 20388 | |
| 1 | 17879 | |
| 0 | 15757 | |
| U | 9994 | 7.0% |
| S | 9994 | 7.0% |
| 4 | 8865 | 6.2% |
| 3 | 8205 | 5.7% |
| 6 | 5429 | 3.8% |
| 5 | 5376 | 3.8% |
| Other values (5) | 12783 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 142716 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 28046 | |
| - | 20388 | |
| 1 | 17879 | |
| 0 | 15757 | |
| U | 9994 | 7.0% |
| S | 9994 | 7.0% |
| 4 | 8865 | 6.2% |
| 3 | 8205 | 5.7% |
| 6 | 5429 | 3.8% |
| 5 | 5376 | 3.8% |
| Other values (5) | 12783 |
Order Date
Date
| Distinct | 1242 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.8 KiB |
| Minimum | 2021-01-03 00:00:00 |
|---|---|
| Maximum | 2024-12-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Ship Date
Date
| Distinct | 1338 |
|---|---|
| Distinct (%) | 13.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.8 KiB |
| Minimum | 2021-01-07 00:00:00 |
|---|---|
| Maximum | 2025-01-05 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Ship Mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 615.7 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 547 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.834216 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Standard Class |
|---|---|
| 2nd row | Standard Class |
| 3rd row | Standard Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 6120 | |
| Second Class | 1979 | 19.4% |
| First Class | 1548 | 15.2% |
| Same Day | 547 | 5.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 9647 | |
| standard | 6120 | |
| second | 1979 | 9.7% |
| first | 1548 | 7.6% |
| same | 547 | 2.7% |
| day | 547 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 22981 | |
| s | 20842 | |
| d | 14219 | |
| 10194 | ||
| l | 9647 | |
| C | 9647 | |
| S | 8646 | 6.6% |
| n | 8099 | 6.2% |
| r | 7668 | 5.9% |
| t | 7668 | 5.9% |
| Other values (8) | 11221 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 130832 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 22981 | |
| s | 20842 | |
| d | 14219 | |
| 10194 | ||
| l | 9647 | |
| C | 9647 | |
| S | 8646 | 6.6% |
| n | 8099 | 6.2% |
| r | 7668 | 5.9% |
| t | 7668 | 5.9% |
| Other values (8) | 11221 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 130832 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 22981 | |
| s | 20842 | |
| d | 14219 | |
| 10194 | ||
| l | 9647 | |
| C | 9647 | |
| S | 8646 | 6.6% |
| n | 8099 | 6.2% |
| r | 7668 | 5.9% |
| t | 7668 | 5.9% |
| Other values (8) | 11221 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 130832 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 22981 | |
| s | 20842 | |
| d | 14219 | |
| 10194 | ||
| l | 9647 | |
| C | 9647 | |
| S | 8646 | 6.6% |
| n | 8099 | 6.2% |
| r | 7668 | 5.9% |
| t | 7668 | 5.9% |
| Other values (8) | 11221 |
Customer ID
Text
| Distinct | 804 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 567.6 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DP-13000 |
|---|---|
| 2nd row | PO-19195 |
| 3rd row | PO-19195 |
| 4th row | PO-19195 |
| 5th row | MB-18085 |
| Value | Count | Frequency (%) |
| wb-21850 | 41 | 0.4% |
| bf-11170 | 37 | 0.4% |
| gg-14650 | 36 | 0.4% |
| jw-15220 | 34 | 0.3% |
| jl-15835 | 34 | 0.3% |
| pp-18955 | 34 | 0.3% |
| ma-17560 | 34 | 0.3% |
| xp-21865 | 34 | 0.3% |
| eh-13765 | 32 | 0.3% |
| ck-12205 | 32 | 0.3% |
| Other values (794) | 9846 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 12177 | |
| - | 10194 | |
| 0 | 8666 | 10.6% |
| 5 | 8049 | 9.9% |
| 2 | 4786 | 5.9% |
| 7 | 2963 | 3.6% |
| 9 | 2960 | 3.6% |
| 6 | 2955 | 3.6% |
| 8 | 2860 | 3.5% |
| 3 | 2839 | 3.5% |
| Other values (30) | 23103 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 81552 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 12177 | |
| - | 10194 | |
| 0 | 8666 | 10.6% |
| 5 | 8049 | 9.9% |
| 2 | 4786 | 5.9% |
| 7 | 2963 | 3.6% |
| 9 | 2960 | 3.6% |
| 6 | 2955 | 3.6% |
| 8 | 2860 | 3.5% |
| 3 | 2839 | 3.5% |
| Other values (30) | 23103 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 81552 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 12177 | |
| - | 10194 | |
| 0 | 8666 | 10.6% |
| 5 | 8049 | 9.9% |
| 2 | 4786 | 5.9% |
| 7 | 2963 | 3.6% |
| 9 | 2960 | 3.6% |
| 6 | 2955 | 3.6% |
| 8 | 2860 | 3.5% |
| 3 | 2839 | 3.5% |
| Other values (30) | 23103 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 81552 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 12177 | |
| - | 10194 | |
| 0 | 8666 | 10.6% |
| 5 | 8049 | 9.9% |
| 2 | 4786 | 5.9% |
| 7 | 2963 | 3.6% |
| 9 | 2960 | 3.6% |
| 6 | 2955 | 3.6% |
| 8 | 2860 | 3.5% |
| 3 | 2839 | 3.5% |
| Other values (30) | 23103 |
Customer Name
Text
| Distinct | 800 |
|---|---|
| Distinct (%) | 7.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.5 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.940651 |
| Min length | 7 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Darren Powers |
|---|---|
| 2nd row | Phillina Ober |
| 3rd row | Phillina Ober |
| 4th row | Phillina Ober |
| 5th row | Mick Brown |
| Value | Count | Frequency (%) |
| michael | 132 | 0.6% |
| frank | 118 | 0.6% |
| john | 107 | 0.5% |
| patrick | 96 | 0.5% |
| brian | 95 | 0.5% |
| stewart | 93 | 0.5% |
| paul | 92 | 0.4% |
| ken | 91 | 0.4% |
| rick | 91 | 0.4% |
| greg | 90 | 0.4% |
| Other values (901) | 19448 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12229 | 9.3% |
| e | 12084 | 9.2% |
| n | 10437 | 7.9% |
| 10259 | 7.8% | |
| r | 9720 | 7.4% |
| i | 8031 | 6.1% |
| l | 6634 | 5.0% |
| o | 5978 | 4.5% |
| t | 5495 | 4.2% |
| s | 4616 | 3.5% |
| Other values (47) | 46434 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 131917 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 12229 | 9.3% |
| e | 12084 | 9.2% |
| n | 10437 | 7.9% |
| 10259 | 7.8% | |
| r | 9720 | 7.4% |
| i | 8031 | 6.1% |
| l | 6634 | 5.0% |
| o | 5978 | 4.5% |
| t | 5495 | 4.2% |
| s | 4616 | 3.5% |
| Other values (47) | 46434 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 131917 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 12229 | 9.3% |
| e | 12084 | 9.2% |
| n | 10437 | 7.9% |
| 10259 | 7.8% | |
| r | 9720 | 7.4% |
| i | 8031 | 6.1% |
| l | 6634 | 5.0% |
| o | 5978 | 4.5% |
| t | 5495 | 4.2% |
| s | 4616 | 3.5% |
| Other values (47) | 46434 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 131917 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 12229 | 9.3% |
| e | 12084 | 9.2% |
| n | 10437 | 7.9% |
| 10259 | 7.8% | |
| r | 9720 | 7.4% |
| i | 8031 | 6.1% |
| l | 6634 | 5.0% |
| o | 5978 | 4.5% |
| t | 5495 | 4.2% |
| s | 4616 | 3.5% |
| Other values (47) | 46434 |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 575.9 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8396115 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Home Office |
| 3rd row | Home Office |
| 4th row | Home Office |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 5281 | |
| Corporate | 3090 | |
| Home Office | 1823 | 17.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 5281 | |
| corporate | 3090 | |
| home | 1823 | 15.2% |
| office | 1823 | 15.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 13284 | |
| e | 12017 | |
| r | 11461 | |
| C | 8371 | |
| m | 7104 | |
| n | 5281 | 5.9% |
| s | 5281 | 5.9% |
| u | 5281 | 5.9% |
| f | 3646 | 4.0% |
| t | 3090 | 3.4% |
| Other values (7) | 15295 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 90111 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 13284 | |
| e | 12017 | |
| r | 11461 | |
| C | 8371 | |
| m | 7104 | |
| n | 5281 | 5.9% |
| s | 5281 | 5.9% |
| u | 5281 | 5.9% |
| f | 3646 | 4.0% |
| t | 3090 | 3.4% |
| Other values (7) | 15295 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 90111 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 13284 | |
| e | 12017 | |
| r | 11461 | |
| C | 8371 | |
| m | 7104 | |
| n | 5281 | 5.9% |
| s | 5281 | 5.9% |
| u | 5281 | 5.9% |
| f | 3646 | 4.0% |
| t | 3090 | 3.4% |
| Other values (7) | 15295 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 90111 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 13284 | |
| e | 12017 | |
| r | 11461 | |
| C | 8371 | |
| m | 7104 | |
| n | 5281 | 5.9% |
| s | 5281 | 5.9% |
| u | 5281 | 5.9% |
| f | 3646 | 4.0% |
| t | 3090 | 3.4% |
| Other values (7) | 15295 |
Country/Region
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 616.0 KiB |
| United States | |
|---|---|
| Canada | 200 |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.862664 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 9994 | |
| Canada | 200 | 2.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 9994 | |
| states | 9994 | |
| canada | 200 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| a | 10594 | 8.1% |
| n | 10194 | 7.8% |
| d | 10194 | 7.8% |
| U | 9994 | 7.6% |
| i | 9994 | 7.6% |
| 9994 | 7.6% | |
| S | 9994 | 7.6% |
| s | 9994 | 7.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 131122 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| a | 10594 | 8.1% |
| n | 10194 | 7.8% |
| d | 10194 | 7.8% |
| U | 9994 | 7.6% |
| i | 9994 | 7.6% |
| 9994 | 7.6% | |
| S | 9994 | 7.6% |
| s | 9994 | 7.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 131122 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| a | 10594 | 8.1% |
| n | 10194 | 7.8% |
| d | 10194 | 7.8% |
| U | 9994 | 7.6% |
| i | 9994 | 7.6% |
| 9994 | 7.6% | |
| S | 9994 | 7.6% |
| s | 9994 | 7.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 131122 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 29982 | |
| e | 19988 | |
| a | 10594 | 8.1% |
| n | 10194 | 7.8% |
| d | 10194 | 7.8% |
| U | 9994 | 7.6% |
| i | 9994 | 7.6% |
| 9994 | 7.6% | |
| S | 9994 | 7.6% |
| s | 9994 | 7.6% |
City
Text
| Distinct | 542 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 580.6 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 9.3083186 |
| Min length | 4 |
Unique
| Unique | 70 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | Houston |
|---|---|
| 2nd row | Naperville |
| 3rd row | Naperville |
| 4th row | Naperville |
| 5th row | Philadelphia |
| Value | Count | Frequency (%) |
| city | 1010 | 7.0% |
| new | 937 | 6.5% |
| york | 920 | 6.4% |
| san | 805 | 5.6% |
| los | 747 | 5.2% |
| angeles | 747 | 5.2% |
| philadelphia | 537 | 3.7% |
| francisco | 510 | 3.5% |
| seattle | 428 | 3.0% |
| houston | 377 | 2.6% |
| Other values (567) | 7440 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8831 | 9.3% |
| o | 7787 | 8.2% |
| a | 7707 | 8.1% |
| n | 6387 | 6.7% |
| i | 6277 | 6.6% |
| l | 6054 | 6.4% |
| s | 4705 | 5.0% |
| r | 4610 | 4.9% |
| t | 4598 | 4.8% |
| 4264 | 4.5% | |
| Other values (43) | 33669 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 94889 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 8831 | 9.3% |
| o | 7787 | 8.2% |
| a | 7707 | 8.1% |
| n | 6387 | 6.7% |
| i | 6277 | 6.6% |
| l | 6054 | 6.4% |
| s | 4705 | 5.0% |
| r | 4610 | 4.9% |
| t | 4598 | 4.8% |
| 4264 | 4.5% | |
| Other values (43) | 33669 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 94889 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 8831 | 9.3% |
| o | 7787 | 8.2% |
| a | 7707 | 8.1% |
| n | 6387 | 6.7% |
| i | 6277 | 6.6% |
| l | 6054 | 6.4% |
| s | 4705 | 5.0% |
| r | 4610 | 4.9% |
| t | 4598 | 4.8% |
| 4264 | 4.5% | |
| Other values (43) | 33669 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 94889 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 8831 | 9.3% |
| o | 7787 | 8.2% |
| a | 7707 | 8.1% |
| n | 6387 | 6.7% |
| i | 6277 | 6.6% |
| l | 6054 | 6.4% |
| s | 4705 | 5.0% |
| r | 4610 | 4.9% |
| t | 4598 | 4.8% |
| 4264 | 4.5% | |
| Other values (43) | 33669 |
State/Province
Text
| Distinct | 59 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 572.6 KiB |
Length
| Max length | 25 |
|---|---|
| Median length | 20 |
| Mean length | 8.505101 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Texas |
|---|---|
| 2nd row | Illinois |
| 3rd row | Illinois |
| 4th row | Illinois |
| 5th row | Pennsylvania |
| Value | Count | Frequency (%) |
| california | 2001 | |
| new | 1330 | 11.1% |
| york | 1128 | 9.4% |
| texas | 985 | 8.2% |
| pennsylvania | 587 | 4.9% |
| washington | 506 | 4.2% |
| illinois | 492 | 4.1% |
| ohio | 469 | 3.9% |
| florida | 383 | 3.2% |
| carolina | 291 | 2.4% |
| Other values (57) | 3802 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 10950 | |
| i | 10055 | |
| n | 8208 | 9.5% |
| o | 7439 | 8.6% |
| r | 5690 | 6.6% |
| e | 5203 | 6.0% |
| l | 4886 | 5.6% |
| s | 4646 | 5.4% |
| C | 2588 | 3.0% |
| f | 2017 | 2.3% |
| Other values (39) | 25019 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 86701 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 10950 | |
| i | 10055 | |
| n | 8208 | 9.5% |
| o | 7439 | 8.6% |
| r | 5690 | 6.6% |
| e | 5203 | 6.0% |
| l | 4886 | 5.6% |
| s | 4646 | 5.4% |
| C | 2588 | 3.0% |
| f | 2017 | 2.3% |
| Other values (39) | 25019 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 86701 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 10950 | |
| i | 10055 | |
| n | 8208 | 9.5% |
| o | 7439 | 8.6% |
| r | 5690 | 6.6% |
| e | 5203 | 6.0% |
| l | 4886 | 5.6% |
| s | 4646 | 5.4% |
| C | 2588 | 3.0% |
| f | 2017 | 2.3% |
| Other values (39) | 25019 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 86701 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 10950 | |
| i | 10055 | |
| n | 8208 | 9.5% |
| o | 7439 | 8.6% |
| r | 5690 | 6.6% |
| e | 5203 | 6.0% |
| l | 4886 | 5.6% |
| s | 4646 | 5.4% |
| C | 2588 | 3.0% |
| f | 2017 | 2.3% |
| Other values (39) | 25019 |
Postal Code
Text
| Distinct | 654 |
|---|---|
| Distinct (%) | 6.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 537.3 KiB |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.9607612 |
| Min length | 3 |
Unique
| Unique | 78 ? |
|---|---|
| Unique (%) | 0.8% |
Sample
| 1st row | 77095 |
|---|---|
| 2nd row | 60540 |
| 3rd row | 60540 |
| 4th row | 60540 |
| 5th row | 19143 |
| Value | Count | Frequency (%) |
| 10035 | 263 | 2.6% |
| 10024 | 230 | 2.3% |
| 10009 | 229 | 2.2% |
| 94122 | 203 | 2.0% |
| 10011 | 193 | 1.9% |
| 94110 | 166 | 1.6% |
| 98105 | 165 | 1.6% |
| 19134 | 160 | 1.6% |
| 90049 | 151 | 1.5% |
| 98103 | 151 | 1.5% |
| Other values (644) | 8283 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10652 | |
| 1 | 7635 | |
| 2 | 5088 | |
| 9 | 4908 | |
| 4 | 4696 | |
| 3 | 4648 | |
| 7 | 3675 | 7.3% |
| 5 | 3621 | 7.2% |
| 8 | 2713 | 5.4% |
| 6 | 2534 | 5.0% |
| Other values (15) | 400 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 50570 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 10652 | |
| 1 | 7635 | |
| 2 | 5088 | |
| 9 | 4908 | |
| 4 | 4696 | |
| 3 | 4648 | |
| 7 | 3675 | 7.3% |
| 5 | 3621 | 7.2% |
| 8 | 2713 | 5.4% |
| 6 | 2534 | 5.0% |
| Other values (15) | 400 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 50570 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 10652 | |
| 1 | 7635 | |
| 2 | 5088 | |
| 9 | 4908 | |
| 4 | 4696 | |
| 3 | 4648 | |
| 7 | 3675 | 7.3% |
| 5 | 3621 | 7.2% |
| 8 | 2713 | 5.4% |
| 6 | 2534 | 5.0% |
| Other values (15) | 400 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 50570 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 10652 | |
| 1 | 7635 | |
| 2 | 5088 | |
| 9 | 4908 | |
| 4 | 4696 | |
| 3 | 4648 | |
| 7 | 3675 | 7.3% |
| 5 | 3621 | 7.2% |
| 8 | 2713 | 5.4% |
| 6 | 2534 | 5.0% |
| Other values (15) | 400 | 0.8% |
Region
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 536.2 KiB |
| West | |
|---|---|
| East | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.8460859 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Central |
|---|---|
| 2nd row | Central |
| 3rd row | Central |
| 4th row | Central |
| 5th row | East |
Common Values
| Value | Count | Frequency (%) |
| West | 3253 | |
| East | 2986 | |
| Central | 2335 | |
| South | 1620 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 3253 | |
| east | 2986 | |
| central | 2335 | |
| south | 1620 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 10194 | |
| s | 6239 | |
| e | 5588 | |
| a | 5321 | |
| W | 3253 | 6.6% |
| E | 2986 | 6.0% |
| C | 2335 | 4.7% |
| n | 2335 | 4.7% |
| r | 2335 | 4.7% |
| l | 2335 | 4.7% |
| Other values (4) | 6480 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 49401 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 10194 | |
| s | 6239 | |
| e | 5588 | |
| a | 5321 | |
| W | 3253 | 6.6% |
| E | 2986 | 6.0% |
| C | 2335 | 4.7% |
| n | 2335 | 4.7% |
| r | 2335 | 4.7% |
| l | 2335 | 4.7% |
| Other values (4) | 6480 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 49401 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 10194 | |
| s | 6239 | |
| e | 5588 | |
| a | 5321 | |
| W | 3253 | 6.6% |
| E | 2986 | 6.0% |
| C | 2335 | 4.7% |
| n | 2335 | 4.7% |
| r | 2335 | 4.7% |
| l | 2335 | 4.7% |
| Other values (4) | 6480 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 49401 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 10194 | |
| s | 6239 | |
| e | 5588 | |
| a | 5321 | |
| W | 3253 | 6.6% |
| E | 2986 | 6.0% |
| C | 2335 | 4.7% |
| n | 2335 | 4.7% |
| r | 2335 | 4.7% |
| l | 2335 | 4.7% |
| Other values (4) | 6480 |
Product ID
Text
| Distinct | 1862 |
|---|---|
| Distinct (%) | 18.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 637.3 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Unique
| Unique | 90 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | OFF-PA-10000174 |
|---|---|
| 2nd row | OFF-BI-10004094 |
| 3rd row | OFF-LA-10003223 |
| 4th row | OFF-ST-10002743 |
| 5th row | OFF-AR-10003478 |
| Value | Count | Frequency (%) |
| fur-fu-10004270 | 20 | 0.2% |
| off-pa-10001970 | 19 | 0.2% |
| tec-ac-10003832 | 18 | 0.2% |
| fur-ch-10002647 | 15 | 0.1% |
| tec-ac-10002049 | 15 | 0.1% |
| fur-ch-10004287 | 15 | 0.1% |
| fur-ch-10001146 | 15 | 0.1% |
| tec-ac-10003628 | 15 | 0.1% |
| fur-ch-10003774 | 14 | 0.1% |
| fur-ta-10003473 | 14 | 0.1% |
| Other values (1852) | 10034 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 35765 | |
| - | 20388 | |
| F | 15695 | |
| 1 | 15294 | |
| O | 6430 | 4.2% |
| 2 | 4969 | 3.2% |
| 4 | 4931 | 3.2% |
| 3 | 4892 | 3.2% |
| A | 4494 | 2.9% |
| 5 | 3455 | 2.3% |
| Other values (17) | 36597 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 152910 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 35765 | |
| - | 20388 | |
| F | 15695 | |
| 1 | 15294 | |
| O | 6430 | 4.2% |
| 2 | 4969 | 3.2% |
| 4 | 4931 | 3.2% |
| 3 | 4892 | 3.2% |
| A | 4494 | 2.9% |
| 5 | 3455 | 2.3% |
| Other values (17) | 36597 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 152910 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 35765 | |
| - | 20388 | |
| F | 15695 | |
| 1 | 15294 | |
| O | 6430 | 4.2% |
| 2 | 4969 | 3.2% |
| 4 | 4931 | 3.2% |
| 3 | 4892 | 3.2% |
| A | 4494 | 2.9% |
| 5 | 3455 | 2.3% |
| Other values (17) | 36597 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 152910 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 35765 | |
| - | 20388 | |
| F | 15695 | |
| 1 | 15294 | |
| O | 6430 | 4.2% |
| 2 | 4969 | 3.2% |
| 4 | 4931 | 3.2% |
| 3 | 4892 | 3.2% |
| A | 4494 | 2.9% |
| 5 | 3455 | 2.3% |
| Other values (17) | 36597 |
Category
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 615.3 KiB |
| Office Supplies | |
|---|---|
| Furniture | |
| Technology |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.789778 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Office Supplies |
|---|---|
| 2nd row | Office Supplies |
| 3rd row | Office Supplies |
| 4th row | Office Supplies |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 6128 | |
| Furniture | 2201 | 21.6% |
| Technology | 1865 | 18.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 6128 | |
| supplies | 6128 | |
| furniture | 2201 | 13.5% |
| technology | 1865 | 11.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 16322 | |
| i | 14457 | |
| p | 12256 | |
| f | 12256 | |
| u | 10530 | 8.1% |
| c | 7993 | 6.1% |
| l | 7993 | 6.1% |
| O | 6128 | 4.7% |
| s | 6128 | 4.7% |
| S | 6128 | 4.7% |
| Other values (10) | 30188 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 130379 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 16322 | |
| i | 14457 | |
| p | 12256 | |
| f | 12256 | |
| u | 10530 | 8.1% |
| c | 7993 | 6.1% |
| l | 7993 | 6.1% |
| O | 6128 | 4.7% |
| s | 6128 | 4.7% |
| S | 6128 | 4.7% |
| Other values (10) | 30188 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 130379 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 16322 | |
| i | 14457 | |
| p | 12256 | |
| f | 12256 | |
| u | 10530 | 8.1% |
| c | 7993 | 6.1% |
| l | 7993 | 6.1% |
| O | 6128 | 4.7% |
| s | 6128 | 4.7% |
| S | 6128 | 4.7% |
| Other values (10) | 30188 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 130379 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 16322 | |
| i | 14457 | |
| p | 12256 | |
| f | 12256 | |
| u | 10530 | 8.1% |
| c | 7993 | 6.1% |
| l | 7993 | 6.1% |
| O | 6128 | 4.7% |
| s | 6128 | 4.7% |
| S | 6128 | 4.7% |
| Other values (10) | 30188 |
Sub-Category
Categorical
High correlation
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 559.6 KiB |
| Binders | |
|---|---|
| Paper | |
| Furnishings | |
| Phones | |
| Storage | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.1979596 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Paper |
|---|---|
| 2nd row | Binders |
| 3rd row | Labels |
| 4th row | Storage |
| 5th row | Art |
Common Values
| Value | Count | Frequency (%) |
| Binders | 1548 | |
| Paper | 1384 | |
| Furnishings | 1009 | |
| Phones | 903 | |
| Storage | 856 | |
| Art | 821 | |
| Accessories | 775 | |
| Chairs | 634 | |
| Appliances | 474 | 4.6% |
| Labels | 368 | 3.6% |
| Other values (7) | 1422 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| binders | 1548 | |
| paper | 1384 | |
| furnishings | 1009 | |
| phones | 903 | |
| storage | 856 | |
| art | 821 | |
| accessories | 775 | |
| chairs | 634 | |
| appliances | 474 | 4.6% |
| labels | 368 | 3.6% |
| Other values (7) | 1422 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 10153 | |
| e | 8990 | |
| r | 7326 | 10.0% |
| i | 5828 | 7.9% |
| n | 5545 | 7.6% |
| a | 4620 | 6.3% |
| o | 3324 | 4.5% |
| p | 3042 | 4.1% |
| h | 2663 | 3.6% |
| c | 2373 | 3.2% |
| Other values (18) | 19512 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 73376 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 10153 | |
| e | 8990 | |
| r | 7326 | 10.0% |
| i | 5828 | 7.9% |
| n | 5545 | 7.6% |
| a | 4620 | 6.3% |
| o | 3324 | 4.5% |
| p | 3042 | 4.1% |
| h | 2663 | 3.6% |
| c | 2373 | 3.2% |
| Other values (18) | 19512 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 73376 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 10153 | |
| e | 8990 | |
| r | 7326 | 10.0% |
| i | 5828 | 7.9% |
| n | 5545 | 7.6% |
| a | 4620 | 6.3% |
| o | 3324 | 4.5% |
| p | 3042 | 4.1% |
| h | 2663 | 3.6% |
| c | 2373 | 3.2% |
| Other values (18) | 19512 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 73376 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 10153 | |
| e | 8990 | |
| r | 7326 | 10.0% |
| i | 5828 | 7.9% |
| n | 5545 | 7.6% |
| a | 4620 | 6.3% |
| o | 3324 | 4.5% |
| p | 3042 | 4.1% |
| h | 2663 | 3.6% |
| c | 2373 | 3.2% |
| Other values (18) | 19512 |
Product Name
Text
| Distinct | 1849 |
|---|---|
| Distinct (%) | 18.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 876.7 KiB |
Length
| Max length | 127 |
|---|---|
| Median length | 78 |
| Mean length | 36.962527 |
| Min length | 5 |
Unique
| Unique | 90 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | Message Book, Wirebound, Four 5 1/2" X 4" Forms/Pg., 200 Dupl. Sets/Book |
|---|---|
| 2nd row | GBC Standard Plastic Binding Systems Combs |
| 3rd row | Avery 508 |
| 4th row | SAFCO Boltless Steel Shelving |
| 5th row | Avery Hi-Liter EverBold Pen Style Fluorescent Highlighters, 4/Pack |
| Value | Count | Frequency (%) |
| xerox | 871 | 1.5% |
| x | 718 | 1.3% |
| 615 | 1.1% | |
| with | 604 | 1.1% |
| avery | 569 | 1.0% |
| for | 551 | 1.0% |
| binders | 528 | 0.9% |
| chair | 493 | 0.9% |
| black | 438 | 0.8% |
| phone | 380 | 0.7% |
| Other values (2798) | 51443 |
Most occurring characters
| Value | Count | Frequency (%) |
| 46630 | 12.4% | |
| e | 34256 | 9.1% |
| r | 21202 | 5.6% |
| o | 20317 | 5.4% |
| a | 19467 | 5.2% |
| i | 19017 | 5.0% |
| l | 16749 | 4.4% |
| n | 15942 | 4.2% |
| s | 14999 | 4.0% |
| t | 14849 | 3.9% |
| Other values (75) | 153368 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 376796 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 46630 | 12.4% | |
| e | 34256 | 9.1% |
| r | 21202 | 5.6% |
| o | 20317 | 5.4% |
| a | 19467 | 5.2% |
| i | 19017 | 5.0% |
| l | 16749 | 4.4% |
| n | 15942 | 4.2% |
| s | 14999 | 4.0% |
| t | 14849 | 3.9% |
| Other values (75) | 153368 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 376796 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 46630 | 12.4% | |
| e | 34256 | 9.1% |
| r | 21202 | 5.6% |
| o | 20317 | 5.4% |
| a | 19467 | 5.2% |
| i | 19017 | 5.0% |
| l | 16749 | 4.4% |
| n | 15942 | 4.2% |
| s | 14999 | 4.0% |
| t | 14849 | 3.9% |
| Other values (75) | 153368 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 376796 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 46630 | 12.4% | |
| e | 34256 | 9.1% |
| r | 21202 | 5.6% |
| o | 20317 | 5.4% |
| a | 19467 | 5.2% |
| i | 19017 | 5.0% |
| l | 16749 | 4.4% |
| n | 15942 | 4.2% |
| s | 14999 | 4.0% |
| t | 14849 | 3.9% |
| Other values (75) | 153368 |
Sales
Real number (ℝ)
High correlation
| Distinct | 6161 |
|---|---|
| Distinct (%) | 60.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 228.22585 |
| Minimum | 0.444 |
|---|---|
| Maximum | 22638.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.8 KiB |
Quantile statistics
| Minimum | 0.444 |
|---|---|
| 5-th percentile | 4.98 |
| Q1 | 17.22 |
| median | 53.91 |
| Q3 | 209.5 |
| 95-th percentile | 943.5351 |
| Maximum | 22638.48 |
| Range | 22638.036 |
| Interquartile range (IQR) | 192.28 |
Descriptive statistics
| Standard deviation | 619.90684 |
|---|---|
| Coefficient of variation (CV) | 2.716199 |
| Kurtosis | 306.36627 |
| Mean | 228.22585 |
| Median Absolute Deviation (MAD) | 44.964 |
| Skewness | 12.983926 |
| Sum | 2326534.4 |
| Variance | 384284.49 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12.96 | 56 | 0.5% |
| 19.44 | 43 | 0.4% |
| 15.552 | 39 | 0.4% |
| 10.368 | 36 | 0.4% |
| 32.4 | 28 | 0.3% |
| 6.48 | 27 | 0.3% |
| 25.92 | 24 | 0.2% |
| 17.94 | 22 | 0.2% |
| 20.736 | 19 | 0.2% |
| 14.94 | 17 | 0.2% |
| Other values (6151) | 9883 |
| Value | Count | Frequency (%) |
| 0.444 | 1 | |
| 0.556 | 1 | |
| 0.836 | 1 | |
| 0.852 | 1 | |
| 0.876 | 1 | |
| 0.898 | 1 | |
| 0.984 | 1 | |
| 0.99 | 1 | |
| 1.044 | 1 | |
| 1.08 | 1 |
| Value | Count | Frequency (%) |
| 22638.48 | 1 | |
| 17499.95 | 1 | |
| 13999.96 | 1 | |
| 11199.968 | 1 | |
| 10499.97 | 1 | |
| 9892.74 | 1 | |
| 9449.95 | 1 | |
| 9099.93 | 1 | |
| 8749.95 | 1 | |
| 8399.976 | 1 |
Quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7918383 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2283168 |
|---|---|
| Coefficient of variation (CV) | 0.58766135 |
| Kurtosis | 1.9615258 |
| Mean | 3.7918383 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.2686325 |
| Sum | 38654 |
| Variance | 4.965396 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 2 | 2440 | |
| 3 | 2435 | |
| 5 | 1269 | |
| 4 | 1212 | |
| 1 | 933 | 9.2% |
| 7 | 617 | 6.1% |
| 6 | 585 | 5.7% |
| 8 | 269 | 2.6% |
| 9 | 259 | 2.5% |
| 10 | 61 | 0.6% |
| Other values (4) | 114 | 1.1% |
| Value | Count | Frequency (%) |
| 1 | 933 | 9.2% |
| 2 | 2440 | |
| 3 | 2435 | |
| 4 | 1212 | |
| 5 | 1269 | |
| 6 | 585 | 5.7% |
| 7 | 617 | 6.1% |
| 8 | 269 | 2.6% |
| 9 | 259 | 2.5% |
| 10 | 61 | 0.6% |
| Value | Count | Frequency (%) |
| 14 | 30 | 0.3% |
| 13 | 27 | 0.3% |
| 12 | 23 | 0.2% |
| 11 | 34 | 0.3% |
| 10 | 61 | 0.6% |
| 9 | 259 | 2.5% |
| 8 | 269 | 2.6% |
| 7 | 617 | |
| 6 | 585 | |
| 5 | 1269 |
Discount
Real number (ℝ)
High correlation Zeros
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15538454 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8 |
| Zeros | 4925 |
| Zeros (%) | 48.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.2 |
| Q3 | 0.2 |
| 95-th percentile | 0.7 |
| Maximum | 0.8 |
| Range | 0.8 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.20624859 |
|---|---|
| Coefficient of variation (CV) | 1.3273431 |
| Kurtosis | 2.4162909 |
| Mean | 0.15538454 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 1.6874528 |
| Sum | 1583.99 |
| Variance | 0.042538482 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 4925 | |
| 0.2 | 3706 | |
| 0.7 | 424 | 4.2% |
| 0.8 | 301 | 3.0% |
| 0.3 | 230 | 2.3% |
| 0.4 | 207 | 2.0% |
| 0.6 | 149 | 1.5% |
| 0.1 | 96 | 0.9% |
| 0.5 | 66 | 0.6% |
| 0.15 | 52 | 0.5% |
| Other values (2) | 38 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 4925 | |
| 0.1 | 96 | 0.9% |
| 0.15 | 52 | 0.5% |
| 0.2 | 3706 | |
| 0.3 | 230 | 2.3% |
| 0.32 | 27 | 0.3% |
| 0.4 | 207 | 2.0% |
| 0.45 | 11 | 0.1% |
| 0.5 | 66 | 0.6% |
| 0.6 | 149 | 1.5% |
| Value | Count | Frequency (%) |
| 0.8 | 301 | 3.0% |
| 0.7 | 424 | 4.2% |
| 0.6 | 149 | 1.5% |
| 0.5 | 66 | 0.6% |
| 0.45 | 11 | 0.1% |
| 0.4 | 207 | 2.0% |
| 0.32 | 27 | 0.3% |
| 0.3 | 230 | 2.3% |
| 0.2 | 3706 | |
| 0.15 | 52 | 0.5% |
Profit
Real number (ℝ)
High correlation
| Distinct | 7597 |
|---|---|
| Distinct (%) | 74.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.673417 |
| Minimum | -6599.978 |
|---|---|
| Maximum | 8399.976 |
| Zeros | 65 |
| Zeros (%) | 0.6% |
| Negative | 1901 |
| Negative (%) | 18.6% |
| Memory size | 79.8 KiB |
Quantile statistics
| Minimum | -6599.978 |
|---|---|
| 5-th percentile | -52.65883 |
| Q1 | 1.7608 |
| median | 8.69 |
| Q3 | 29.297925 |
| 95-th percentile | 168.4496 |
| Maximum | 8399.976 |
| Range | 14999.954 |
| Interquartile range (IQR) | 27.537125 |
Descriptive statistics
| Standard deviation | 232.46512 |
|---|---|
| Coefficient of variation (CV) | 8.1073391 |
| Kurtosis | 401.69292 |
| Mean | 28.673417 |
| Median Absolute Deviation (MAD) | 10.7372 |
| Skewness | 7.6049059 |
| Sum | 292296.81 |
| Variance | 54040.03 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 65 | 0.6% |
| 6.2208 | 43 | 0.4% |
| 9.3312 | 39 | 0.4% |
| 3.6288 | 32 | 0.3% |
| 5.4432 | 32 | 0.3% |
| 15.552 | 26 | 0.3% |
| 12.4416 | 21 | 0.2% |
| 7.2576 | 19 | 0.2% |
| 3.1104 | 18 | 0.2% |
| 9.072 | 11 | 0.1% |
| Other values (7587) | 9888 |
| Value | Count | Frequency (%) |
| -6599.978 | 1 | |
| -3839.9904 | 1 | |
| -3701.8928 | 1 | |
| -3399.98 | 1 | |
| -2929.4845 | 1 | |
| -2639.9912 | 1 | |
| -2287.782 | 1 | |
| -1862.3124 | 1 | |
| -1850.9464 | 1 | |
| -1811.0784 | 1 |
| Value | Count | Frequency (%) |
| 8399.976 | 1 | |
| 6719.9808 | 1 | |
| 5039.9856 | 1 | |
| 4946.37 | 1 | |
| 4630.4755 | 1 | |
| 3919.9888 | 1 | |
| 3177.475 | 1 | |
| 2799.984 | 1 | |
| 2591.9568 | 1 | |
| 2504.2216 | 1 |
Interactions
Correlations
| Category | Country/Region | Discount | Profit | Quantity | Region | Row ID | Sales | Segment | Ship Mode | Sub-Category | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | 1.000 | 0.065 | 0.372 | 0.055 | 0.000 | 0.000 | 0.000 | 0.071 | 0.000 | 0.000 | 0.999 |
| Country/Region | 0.065 | 1.000 | 0.064 | 0.000 | 0.043 | 0.128 | 0.032 | 0.000 | 0.013 | 0.049 | 0.093 |
| Discount | 0.372 | 0.064 | 1.000 | -0.541 | -0.001 | 0.290 | -0.001 | -0.053 | 0.000 | 0.025 | 0.349 |
| Profit | 0.055 | 0.000 | -0.541 | 1.000 | 0.235 | 0.020 | -0.000 | 0.520 | 0.000 | 0.006 | 0.128 |
| Quantity | 0.000 | 0.043 | -0.001 | 0.235 | 1.000 | 0.000 | -0.000 | 0.326 | 0.018 | 0.000 | 0.002 |
| Region | 0.000 | 0.128 | 0.290 | 0.020 | 0.000 | 1.000 | 0.054 | 0.000 | 0.003 | 0.018 | 0.000 |
| Row ID | 0.000 | 0.032 | -0.001 | -0.000 | -0.000 | 0.054 | 1.000 | -0.003 | 0.038 | 0.035 | 0.000 |
| Sales | 0.071 | 0.000 | -0.053 | 0.520 | 0.326 | 0.000 | -0.003 | 1.000 | 0.007 | 0.000 | 0.139 |
| Segment | 0.000 | 0.013 | 0.000 | 0.000 | 0.018 | 0.003 | 0.038 | 0.007 | 1.000 | 0.030 | 0.000 |
| Ship Mode | 0.000 | 0.049 | 0.025 | 0.006 | 0.000 | 0.018 | 0.035 | 0.000 | 0.030 | 1.000 | 0.012 |
| Sub-Category | 0.999 | 0.093 | 0.349 | 0.128 | 0.002 | 0.000 | 0.000 | 0.139 | 0.000 | 0.012 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country/Region | City | State/Province | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | US-2021-103800 | 2021-01-03 | 2021-01-07 | Standard Class | DP-13000 | Darren Powers | Consumer | United States | Houston | Texas | 77095 | Central | OFF-PA-10000174 | Office Supplies | Paper | Message Book, Wirebound, Four 5 1/2" X 4" Forms/Pg., 200 Dupl. Sets/Book | 16.448 | 2 | 0.2 | 5.5512 |
| 1 | 2 | US-2021-112326 | 2021-01-04 | 2021-01-08 | Standard Class | PO-19195 | Phillina Ober | Home Office | United States | Naperville | Illinois | 60540 | Central | OFF-BI-10004094 | Office Supplies | Binders | GBC Standard Plastic Binding Systems Combs | 3.540 | 2 | 0.8 | -5.4870 |
| 2 | 3 | US-2021-112326 | 2021-01-04 | 2021-01-08 | Standard Class | PO-19195 | Phillina Ober | Home Office | United States | Naperville | Illinois | 60540 | Central | OFF-LA-10003223 | Office Supplies | Labels | Avery 508 | 11.784 | 3 | 0.2 | 4.2717 |
| 3 | 4 | US-2021-112326 | 2021-01-04 | 2021-01-08 | Standard Class | PO-19195 | Phillina Ober | Home Office | United States | Naperville | Illinois | 60540 | Central | OFF-ST-10002743 | Office Supplies | Storage | SAFCO Boltless Steel Shelving | 272.736 | 3 | 0.2 | -64.7748 |
| 4 | 5 | US-2021-141817 | 2021-01-05 | 2021-01-12 | Standard Class | MB-18085 | Mick Brown | Consumer | United States | Philadelphia | Pennsylvania | 19143 | East | OFF-AR-10003478 | Office Supplies | Art | Avery Hi-Liter EverBold Pen Style Fluorescent Highlighters, 4/Pack | 19.536 | 3 | 0.2 | 4.8840 |
| 5 | 6 | US-2021-167199 | 2021-01-06 | 2021-01-10 | Standard Class | ME-17320 | Maria Etezadi | Home Office | United States | Henderson | Kentucky | 42420 | South | FUR-CH-10004063 | Furniture | Chairs | Global Deluxe High-Back Manager's Chair | 2573.820 | 9 | 0.0 | 746.4078 |
| 6 | 7 | US-2021-167199 | 2021-01-06 | 2021-01-10 | Standard Class | ME-17320 | Maria Etezadi | Home Office | United States | Henderson | Kentucky | 42420 | South | OFF-AR-10001662 | Office Supplies | Art | Rogers Handheld Barrel Pencil Sharpener | 5.480 | 2 | 0.0 | 1.4796 |
| 7 | 8 | US-2021-106054 | 2021-01-06 | 2021-01-07 | First Class | JO-15145 | Jack O'Briant | Corporate | United States | Athens | Georgia | 30605 | South | OFF-AR-10002399 | Office Supplies | Art | Dixon Prang Watercolor Pencils, 10-Color Set with Brush | 12.780 | 3 | 0.0 | 5.2398 |
| 8 | 9 | US-2021-167199 | 2021-01-06 | 2021-01-10 | Standard Class | ME-17320 | Maria Etezadi | Home Office | United States | Henderson | Kentucky | 42420 | South | OFF-BI-10004632 | Office Supplies | Binders | Ibico Hi-Tech Manual Binding System | 609.980 | 2 | 0.0 | 274.4910 |
| 9 | 10 | US-2021-167199 | 2021-01-06 | 2021-01-10 | Standard Class | ME-17320 | Maria Etezadi | Home Office | United States | Henderson | Kentucky | 42420 | South | OFF-FA-10001883 | Office Supplies | Fasteners | Alliance Super-Size Bands, Assorted Sizes | 31.120 | 4 | 0.0 | 0.3112 |
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country/Region | City | State/Province | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10184 | 10185 | CA-2024-141531 | 2024-12-29 | 2025-01-02 | Standard Class | BG-18435 | Bruce Galang | Consumer | Canada | Quebec City | Quebec | G1B | East | FUR-FU-10004093 | Furniture | Furnishings | Hand-Finished Solid Wood Document Frame | 68.460 | 2 | 0.0 | 20.5380 |
| 10185 | 10186 | CA-2024-141531 | 2024-12-29 | 2025-01-02 | Standard Class | BG-18435 | Bruce Galang | Consumer | Canada | Quebec City | Quebec | G1B | East | OFF-FA-10000089 | Office Supplies | Fasteners | Acco Glide Clips | 19.600 | 5 | 0.0 | 9.6040 |
| 10186 | 10187 | US-2024-143259 | 2024-12-30 | 2025-01-03 | Standard Class | PO-18865 | Patrick O'Donnell | Consumer | United States | New York City | New York | 10009 | East | FUR-BO-10003441 | Furniture | Bookcases | Bush Westfield Collection Bookcases, Fully Assembled | 323.136 | 4 | 0.2 | 12.1176 |
| 10187 | 10188 | US-2024-126221 | 2024-12-30 | 2025-01-05 | Standard Class | CC-12430 | Chuck Clark | Home Office | United States | Columbus | Indiana | 47201 | Central | OFF-AP-10002457 | Office Supplies | Appliances | Eureka The Boss Plus 12-Amp Hard Box Upright Vacuum, Red | 209.300 | 2 | 0.0 | 56.5110 |
| 10188 | 10189 | US-2024-115427 | 2024-12-30 | 2025-01-03 | Standard Class | EB-13975 | Erica Bern | Corporate | United States | Fairfield | California | 94533 | West | OFF-BI-10002103 | Office Supplies | Binders | Cardinal Slant-D Ring Binder, Heavy Gauge Vinyl | 13.904 | 2 | 0.2 | 4.5188 |
| 10189 | 10190 | US-2024-143259 | 2024-12-30 | 2025-01-03 | Standard Class | PO-18865 | Patrick O'Donnell | Consumer | United States | New York City | New York | 10009 | East | OFF-BI-10003684 | Office Supplies | Binders | Wilson Jones Legal Size Ring Binders | 52.776 | 3 | 0.2 | 19.7910 |
| 10190 | 10191 | US-2024-115427 | 2024-12-30 | 2025-01-03 | Standard Class | EB-13975 | Erica Bern | Corporate | United States | Fairfield | California | 94533 | West | OFF-BI-10004632 | Office Supplies | Binders | GBC Binding covers | 20.720 | 2 | 0.2 | 6.4750 |
| 10191 | 10192 | US-2024-156720 | 2024-12-30 | 2025-01-03 | Standard Class | JM-15580 | Jill Matthias | Consumer | United States | Loveland | Colorado | 80538 | West | OFF-FA-10003472 | Office Supplies | Fasteners | Bagged Rubber Bands | 3.024 | 3 | 0.2 | -0.6048 |
| 10192 | 10193 | US-2024-143259 | 2024-12-30 | 2025-01-03 | Standard Class | PO-18865 | Patrick O'Donnell | Consumer | United States | New York City | New York | 10009 | East | TEC-PH-10004774 | Technology | Phones | Gear Head AU3700S Headset | 90.930 | 7 | 0.0 | 2.7279 |
| 10193 | 10194 | CA-2024-143500 | 2024-12-30 | 2025-01-03 | Standard Class | HO-15230 | Harry Olson | Consumer | Canada | Charlottetown | Prince Edward Island | C0A | East | OFF-BI-10004040 | Office Supplies | Binders | Wilson Jones Impact Binders | 3.024 | 3 | 0.2 | -0.6048 |